<html><head><title>select</title><meta name="HandheldFriendly" content="True"></head><body>Retrieves data from tables, views, parameters. Optionally creates a table and stores the data into it. Assigns values to parameters.<br><br><b>select</b> [<b>all</b> | <b>distinct</b> | <b>top</b> value] result_set_list [<b>into</b> [[database.]owner.]table [<a href="q307690.html">select into options</a>]] [<a href="q307689.html">from_clause</a>] [where_clause] [<a href="q307684.html">group by</a>] [<a href="q307685.html">having clause</a>] [<a href="q307686.html">order by</a>] [<a href="q307683.html">compute</a>] [<a href="q307688.html">at isolation options</a>] [<b>for</b> <b>browse</b>] [<b>plan</b> "abstract_plan"]</body></html>